package com.lifesea.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class GhOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public GhOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andBookIdIsNull() {
            addCriterion("BOOK_ID is null");
            return (Criteria) this;
        }

        public Criteria andBookIdIsNotNull() {
            addCriterion("BOOK_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBookIdEqualTo(Long value) {
            addCriterion("BOOK_ID =", value, "bookId");
            return (Criteria) this;
        }

        public Criteria andBookIdNotEqualTo(Long value) {
            addCriterion("BOOK_ID <>", value, "bookId");
            return (Criteria) this;
        }

        public Criteria andBookIdGreaterThan(Long value) {
            addCriterion("BOOK_ID >", value, "bookId");
            return (Criteria) this;
        }

        public Criteria andBookIdGreaterThanOrEqualTo(Long value) {
            addCriterion("BOOK_ID >=", value, "bookId");
            return (Criteria) this;
        }

        public Criteria andBookIdLessThan(Long value) {
            addCriterion("BOOK_ID <", value, "bookId");
            return (Criteria) this;
        }

        public Criteria andBookIdLessThanOrEqualTo(Long value) {
            addCriterion("BOOK_ID <=", value, "bookId");
            return (Criteria) this;
        }

        public Criteria andBookIdIn(List<Long> values) {
            addCriterion("BOOK_ID in", values, "bookId");
            return (Criteria) this;
        }

        public Criteria andBookIdNotIn(List<Long> values) {
            addCriterion("BOOK_ID not in", values, "bookId");
            return (Criteria) this;
        }

        public Criteria andBookIdBetween(Long value1, Long value2) {
            addCriterion("BOOK_ID between", value1, value2, "bookId");
            return (Criteria) this;
        }

        public Criteria andBookIdNotBetween(Long value1, Long value2) {
            addCriterion("BOOK_ID not between", value1, value2, "bookId");
            return (Criteria) this;
        }

        public Criteria andHosIdIsNull() {
            addCriterion("HOS_ID is null");
            return (Criteria) this;
        }

        public Criteria andHosIdIsNotNull() {
            addCriterion("HOS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andHosIdEqualTo(Integer value) {
            addCriterion("HOS_ID =", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdNotEqualTo(Integer value) {
            addCriterion("HOS_ID <>", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdGreaterThan(Integer value) {
            addCriterion("HOS_ID >", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("HOS_ID >=", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdLessThan(Integer value) {
            addCriterion("HOS_ID <", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdLessThanOrEqualTo(Integer value) {
            addCriterion("HOS_ID <=", value, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdIn(List<Integer> values) {
            addCriterion("HOS_ID in", values, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdNotIn(List<Integer> values) {
            addCriterion("HOS_ID not in", values, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdBetween(Integer value1, Integer value2) {
            addCriterion("HOS_ID between", value1, value2, "hosId");
            return (Criteria) this;
        }

        public Criteria andHosIdNotBetween(Integer value1, Integer value2) {
            addCriterion("HOS_ID not between", value1, value2, "hosId");
            return (Criteria) this;
        }

        public Criteria andBranchIdIsNull() {
            addCriterion("BRANCH_ID is null");
            return (Criteria) this;
        }

        public Criteria andBranchIdIsNotNull() {
            addCriterion("BRANCH_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBranchIdEqualTo(Integer value) {
            addCriterion("BRANCH_ID =", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdNotEqualTo(Integer value) {
            addCriterion("BRANCH_ID <>", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdGreaterThan(Integer value) {
            addCriterion("BRANCH_ID >", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("BRANCH_ID >=", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdLessThan(Integer value) {
            addCriterion("BRANCH_ID <", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdLessThanOrEqualTo(Integer value) {
            addCriterion("BRANCH_ID <=", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdIn(List<Integer> values) {
            addCriterion("BRANCH_ID in", values, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdNotIn(List<Integer> values) {
            addCriterion("BRANCH_ID not in", values, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdBetween(Integer value1, Integer value2) {
            addCriterion("BRANCH_ID between", value1, value2, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdNotBetween(Integer value1, Integer value2) {
            addCriterion("BRANCH_ID not between", value1, value2, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchNameIsNull() {
            addCriterion("BRANCH_NAME is null");
            return (Criteria) this;
        }

        public Criteria andBranchNameIsNotNull() {
            addCriterion("BRANCH_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andBranchNameEqualTo(String value) {
            addCriterion("BRANCH_NAME =", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameNotEqualTo(String value) {
            addCriterion("BRANCH_NAME <>", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameGreaterThan(String value) {
            addCriterion("BRANCH_NAME >", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameGreaterThanOrEqualTo(String value) {
            addCriterion("BRANCH_NAME >=", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameLessThan(String value) {
            addCriterion("BRANCH_NAME <", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameLessThanOrEqualTo(String value) {
            addCriterion("BRANCH_NAME <=", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameLike(String value) {
            addCriterion("BRANCH_NAME like", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameNotLike(String value) {
            addCriterion("BRANCH_NAME not like", value, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameIn(List<String> values) {
            addCriterion("BRANCH_NAME in", values, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameNotIn(List<String> values) {
            addCriterion("BRANCH_NAME not in", values, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameBetween(String value1, String value2) {
            addCriterion("BRANCH_NAME between", value1, value2, "branchName");
            return (Criteria) this;
        }

        public Criteria andBranchNameNotBetween(String value1, String value2) {
            addCriterion("BRANCH_NAME not between", value1, value2, "branchName");
            return (Criteria) this;
        }

        public Criteria andDocIdIsNull() {
            addCriterion("DOC_ID is null");
            return (Criteria) this;
        }

        public Criteria andDocIdIsNotNull() {
            addCriterion("DOC_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDocIdEqualTo(Integer value) {
            addCriterion("DOC_ID =", value, "docId");
            return (Criteria) this;
        }

        public Criteria andDocIdNotEqualTo(Integer value) {
            addCriterion("DOC_ID <>", value, "docId");
            return (Criteria) this;
        }

        public Criteria andDocIdGreaterThan(Integer value) {
            addCriterion("DOC_ID >", value, "docId");
            return (Criteria) this;
        }

        public Criteria andDocIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DOC_ID >=", value, "docId");
            return (Criteria) this;
        }

        public Criteria andDocIdLessThan(Integer value) {
            addCriterion("DOC_ID <", value, "docId");
            return (Criteria) this;
        }

        public Criteria andDocIdLessThanOrEqualTo(Integer value) {
            addCriterion("DOC_ID <=", value, "docId");
            return (Criteria) this;
        }

        public Criteria andDocIdIn(List<Integer> values) {
            addCriterion("DOC_ID in", values, "docId");
            return (Criteria) this;
        }

        public Criteria andDocIdNotIn(List<Integer> values) {
            addCriterion("DOC_ID not in", values, "docId");
            return (Criteria) this;
        }

        public Criteria andDocIdBetween(Integer value1, Integer value2) {
            addCriterion("DOC_ID between", value1, value2, "docId");
            return (Criteria) this;
        }

        public Criteria andDocIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DOC_ID not between", value1, value2, "docId");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNull() {
            addCriterion("DEPT_ID is null");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNotNull() {
            addCriterion("DEPT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDeptIdEqualTo(Integer value) {
            addCriterion("DEPT_ID =", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotEqualTo(Integer value) {
            addCriterion("DEPT_ID <>", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThan(Integer value) {
            addCriterion("DEPT_ID >", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DEPT_ID >=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThan(Integer value) {
            addCriterion("DEPT_ID <", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThanOrEqualTo(Integer value) {
            addCriterion("DEPT_ID <=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdIn(List<Integer> values) {
            addCriterion("DEPT_ID in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotIn(List<Integer> values) {
            addCriterion("DEPT_ID not in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdBetween(Integer value1, Integer value2) {
            addCriterion("DEPT_ID between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DEPT_ID not between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andSchIdIsNull() {
            addCriterion("SCH_ID is null");
            return (Criteria) this;
        }

        public Criteria andSchIdIsNotNull() {
            addCriterion("SCH_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSchIdEqualTo(String value) {
            addCriterion("SCH_ID =", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdNotEqualTo(String value) {
            addCriterion("SCH_ID <>", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdGreaterThan(String value) {
            addCriterion("SCH_ID >", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdGreaterThanOrEqualTo(String value) {
            addCriterion("SCH_ID >=", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdLessThan(String value) {
            addCriterion("SCH_ID <", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdLessThanOrEqualTo(String value) {
            addCriterion("SCH_ID <=", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdLike(String value) {
            addCriterion("SCH_ID like", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdNotLike(String value) {
            addCriterion("SCH_ID not like", value, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdIn(List<String> values) {
            addCriterion("SCH_ID in", values, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdNotIn(List<String> values) {
            addCriterion("SCH_ID not in", values, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdBetween(String value1, String value2) {
            addCriterion("SCH_ID between", value1, value2, "schId");
            return (Criteria) this;
        }

        public Criteria andSchIdNotBetween(String value1, String value2) {
            addCriterion("SCH_ID not between", value1, value2, "schId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdIsNull() {
            addCriterion("HIS_SCH_ID is null");
            return (Criteria) this;
        }

        public Criteria andHisSchIdIsNotNull() {
            addCriterion("HIS_SCH_ID is not null");
            return (Criteria) this;
        }

        public Criteria andHisSchIdEqualTo(String value) {
            addCriterion("HIS_SCH_ID =", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdNotEqualTo(String value) {
            addCriterion("HIS_SCH_ID <>", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdGreaterThan(String value) {
            addCriterion("HIS_SCH_ID >", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdGreaterThanOrEqualTo(String value) {
            addCriterion("HIS_SCH_ID >=", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdLessThan(String value) {
            addCriterion("HIS_SCH_ID <", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdLessThanOrEqualTo(String value) {
            addCriterion("HIS_SCH_ID <=", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdLike(String value) {
            addCriterion("HIS_SCH_ID like", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdNotLike(String value) {
            addCriterion("HIS_SCH_ID not like", value, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdIn(List<String> values) {
            addCriterion("HIS_SCH_ID in", values, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdNotIn(List<String> values) {
            addCriterion("HIS_SCH_ID not in", values, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdBetween(String value1, String value2) {
            addCriterion("HIS_SCH_ID between", value1, value2, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andHisSchIdNotBetween(String value1, String value2) {
            addCriterion("HIS_SCH_ID not between", value1, value2, "hisSchId");
            return (Criteria) this;
        }

        public Criteria andSchTypeIsNull() {
            addCriterion("SCH_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andSchTypeIsNotNull() {
            addCriterion("SCH_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andSchTypeEqualTo(Integer value) {
            addCriterion("SCH_TYPE =", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeNotEqualTo(Integer value) {
            addCriterion("SCH_TYPE <>", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeGreaterThan(Integer value) {
            addCriterion("SCH_TYPE >", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("SCH_TYPE >=", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeLessThan(Integer value) {
            addCriterion("SCH_TYPE <", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeLessThanOrEqualTo(Integer value) {
            addCriterion("SCH_TYPE <=", value, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeIn(List<Integer> values) {
            addCriterion("SCH_TYPE in", values, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeNotIn(List<Integer> values) {
            addCriterion("SCH_TYPE not in", values, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeBetween(Integer value1, Integer value2) {
            addCriterion("SCH_TYPE between", value1, value2, "schType");
            return (Criteria) this;
        }

        public Criteria andSchTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("SCH_TYPE not between", value1, value2, "schType");
            return (Criteria) this;
        }

        public Criteria andSchDateIsNull() {
            addCriterion("SCH_DATE is null");
            return (Criteria) this;
        }

        public Criteria andSchDateIsNotNull() {
            addCriterion("SCH_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andSchDateEqualTo(Date value) {
            addCriterionForJDBCDate("SCH_DATE =", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("SCH_DATE <>", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateGreaterThan(Date value) {
            addCriterionForJDBCDate("SCH_DATE >", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("SCH_DATE >=", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateLessThan(Date value) {
            addCriterionForJDBCDate("SCH_DATE <", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("SCH_DATE <=", value, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateIn(List<Date> values) {
            addCriterionForJDBCDate("SCH_DATE in", values, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("SCH_DATE not in", values, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("SCH_DATE between", value1, value2, "schDate");
            return (Criteria) this;
        }

        public Criteria andSchDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("SCH_DATE not between", value1, value2, "schDate");
            return (Criteria) this;
        }

        public Criteria andPointIdIsNull() {
            addCriterion("POINT_ID is null");
            return (Criteria) this;
        }

        public Criteria andPointIdIsNotNull() {
            addCriterion("POINT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPointIdEqualTo(String value) {
            addCriterion("POINT_ID =", value, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdNotEqualTo(String value) {
            addCriterion("POINT_ID <>", value, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdGreaterThan(String value) {
            addCriterion("POINT_ID >", value, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdGreaterThanOrEqualTo(String value) {
            addCriterion("POINT_ID >=", value, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdLessThan(String value) {
            addCriterion("POINT_ID <", value, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdLessThanOrEqualTo(String value) {
            addCriterion("POINT_ID <=", value, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdLike(String value) {
            addCriterion("POINT_ID like", value, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdNotLike(String value) {
            addCriterion("POINT_ID not like", value, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdIn(List<String> values) {
            addCriterion("POINT_ID in", values, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdNotIn(List<String> values) {
            addCriterion("POINT_ID not in", values, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdBetween(String value1, String value2) {
            addCriterion("POINT_ID between", value1, value2, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointIdNotBetween(String value1, String value2) {
            addCriterion("POINT_ID not between", value1, value2, "pointId");
            return (Criteria) this;
        }

        public Criteria andPointSeqIsNull() {
            addCriterion("POINT_SEQ is null");
            return (Criteria) this;
        }

        public Criteria andPointSeqIsNotNull() {
            addCriterion("POINT_SEQ is not null");
            return (Criteria) this;
        }

        public Criteria andPointSeqEqualTo(String value) {
            addCriterion("POINT_SEQ =", value, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqNotEqualTo(String value) {
            addCriterion("POINT_SEQ <>", value, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqGreaterThan(String value) {
            addCriterion("POINT_SEQ >", value, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqGreaterThanOrEqualTo(String value) {
            addCriterion("POINT_SEQ >=", value, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqLessThan(String value) {
            addCriterion("POINT_SEQ <", value, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqLessThanOrEqualTo(String value) {
            addCriterion("POINT_SEQ <=", value, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqLike(String value) {
            addCriterion("POINT_SEQ like", value, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqNotLike(String value) {
            addCriterion("POINT_SEQ not like", value, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqIn(List<String> values) {
            addCriterion("POINT_SEQ in", values, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqNotIn(List<String> values) {
            addCriterion("POINT_SEQ not in", values, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqBetween(String value1, String value2) {
            addCriterion("POINT_SEQ between", value1, value2, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andPointSeqNotBetween(String value1, String value2) {
            addCriterion("POINT_SEQ not between", value1, value2, "pointSeq");
            return (Criteria) this;
        }

        public Criteria andTimeFlagIsNull() {
            addCriterion("TIME_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andTimeFlagIsNotNull() {
            addCriterion("TIME_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andTimeFlagEqualTo(Integer value) {
            addCriterion("TIME_FLAG =", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagNotEqualTo(Integer value) {
            addCriterion("TIME_FLAG <>", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagGreaterThan(Integer value) {
            addCriterion("TIME_FLAG >", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("TIME_FLAG >=", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagLessThan(Integer value) {
            addCriterion("TIME_FLAG <", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagLessThanOrEqualTo(Integer value) {
            addCriterion("TIME_FLAG <=", value, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagIn(List<Integer> values) {
            addCriterion("TIME_FLAG in", values, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagNotIn(List<Integer> values) {
            addCriterion("TIME_FLAG not in", values, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagBetween(Integer value1, Integer value2) {
            addCriterion("TIME_FLAG between", value1, value2, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andTimeFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("TIME_FLAG not between", value1, value2, "timeFlag");
            return (Criteria) this;
        }

        public Criteria andSchTimeIsNull() {
            addCriterion("SCH_TIME is null");
            return (Criteria) this;
        }

        public Criteria andSchTimeIsNotNull() {
            addCriterion("SCH_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andSchTimeEqualTo(String value) {
            addCriterion("SCH_TIME =", value, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeNotEqualTo(String value) {
            addCriterion("SCH_TIME <>", value, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeGreaterThan(String value) {
            addCriterion("SCH_TIME >", value, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeGreaterThanOrEqualTo(String value) {
            addCriterion("SCH_TIME >=", value, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeLessThan(String value) {
            addCriterion("SCH_TIME <", value, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeLessThanOrEqualTo(String value) {
            addCriterion("SCH_TIME <=", value, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeLike(String value) {
            addCriterion("SCH_TIME like", value, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeNotLike(String value) {
            addCriterion("SCH_TIME not like", value, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeIn(List<String> values) {
            addCriterion("SCH_TIME in", values, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeNotIn(List<String> values) {
            addCriterion("SCH_TIME not in", values, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeBetween(String value1, String value2) {
            addCriterion("SCH_TIME between", value1, value2, "schTime");
            return (Criteria) this;
        }

        public Criteria andSchTimeNotBetween(String value1, String value2) {
            addCriterion("SCH_TIME not between", value1, value2, "schTime");
            return (Criteria) this;
        }

        public Criteria andUidIsNull() {
            addCriterion("UID is null");
            return (Criteria) this;
        }

        public Criteria andUidIsNotNull() {
            addCriterion("UID is not null");
            return (Criteria) this;
        }

        public Criteria andUidEqualTo(String value) {
            addCriterion("UID =", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotEqualTo(String value) {
            addCriterion("UID <>", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidGreaterThan(String value) {
            addCriterion("UID >", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidGreaterThanOrEqualTo(String value) {
            addCriterion("UID >=", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidLessThan(String value) {
            addCriterion("UID <", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidLessThanOrEqualTo(String value) {
            addCriterion("UID <=", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidLike(String value) {
            addCriterion("UID like", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotLike(String value) {
            addCriterion("UID not like", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidIn(List<String> values) {
            addCriterion("UID in", values, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotIn(List<String> values) {
            addCriterion("UID not in", values, "uid");
            return (Criteria) this;
        }

        public Criteria andUidBetween(String value1, String value2) {
            addCriterion("UID between", value1, value2, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotBetween(String value1, String value2) {
            addCriterion("UID not between", value1, value2, "uid");
            return (Criteria) this;
        }

        public Criteria andUtypeIsNull() {
            addCriterion("UTYPE is null");
            return (Criteria) this;
        }

        public Criteria andUtypeIsNotNull() {
            addCriterion("UTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andUtypeEqualTo(Short value) {
            addCriterion("UTYPE =", value, "utype");
            return (Criteria) this;
        }

        public Criteria andUtypeNotEqualTo(Short value) {
            addCriterion("UTYPE <>", value, "utype");
            return (Criteria) this;
        }

        public Criteria andUtypeGreaterThan(Short value) {
            addCriterion("UTYPE >", value, "utype");
            return (Criteria) this;
        }

        public Criteria andUtypeGreaterThanOrEqualTo(Short value) {
            addCriterion("UTYPE >=", value, "utype");
            return (Criteria) this;
        }

        public Criteria andUtypeLessThan(Short value) {
            addCriterion("UTYPE <", value, "utype");
            return (Criteria) this;
        }

        public Criteria andUtypeLessThanOrEqualTo(Short value) {
            addCriterion("UTYPE <=", value, "utype");
            return (Criteria) this;
        }

        public Criteria andUtypeIn(List<Short> values) {
            addCriterion("UTYPE in", values, "utype");
            return (Criteria) this;
        }

        public Criteria andUtypeNotIn(List<Short> values) {
            addCriterion("UTYPE not in", values, "utype");
            return (Criteria) this;
        }

        public Criteria andUtypeBetween(Short value1, Short value2) {
            addCriterion("UTYPE between", value1, value2, "utype");
            return (Criteria) this;
        }

        public Criteria andUtypeNotBetween(Short value1, Short value2) {
            addCriterion("UTYPE not between", value1, value2, "utype");
            return (Criteria) this;
        }

        public Criteria andUnameIsNull() {
            addCriterion("UNAME is null");
            return (Criteria) this;
        }

        public Criteria andUnameIsNotNull() {
            addCriterion("UNAME is not null");
            return (Criteria) this;
        }

        public Criteria andUnameEqualTo(String value) {
            addCriterion("UNAME =", value, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameNotEqualTo(String value) {
            addCriterion("UNAME <>", value, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameGreaterThan(String value) {
            addCriterion("UNAME >", value, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameGreaterThanOrEqualTo(String value) {
            addCriterion("UNAME >=", value, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameLessThan(String value) {
            addCriterion("UNAME <", value, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameLessThanOrEqualTo(String value) {
            addCriterion("UNAME <=", value, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameLike(String value) {
            addCriterion("UNAME like", value, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameNotLike(String value) {
            addCriterion("UNAME not like", value, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameIn(List<String> values) {
            addCriterion("UNAME in", values, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameNotIn(List<String> values) {
            addCriterion("UNAME not in", values, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameBetween(String value1, String value2) {
            addCriterion("UNAME between", value1, value2, "uname");
            return (Criteria) this;
        }

        public Criteria andUnameNotBetween(String value1, String value2) {
            addCriterion("UNAME not between", value1, value2, "uname");
            return (Criteria) this;
        }

        public Criteria andPatIdIsNull() {
            addCriterion("PAT_ID is null");
            return (Criteria) this;
        }

        public Criteria andPatIdIsNotNull() {
            addCriterion("PAT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPatIdEqualTo(Long value) {
            addCriterion("PAT_ID =", value, "patId");
            return (Criteria) this;
        }

        public Criteria andPatIdNotEqualTo(Long value) {
            addCriterion("PAT_ID <>", value, "patId");
            return (Criteria) this;
        }

        public Criteria andPatIdGreaterThan(Long value) {
            addCriterion("PAT_ID >", value, "patId");
            return (Criteria) this;
        }

        public Criteria andPatIdGreaterThanOrEqualTo(Long value) {
            addCriterion("PAT_ID >=", value, "patId");
            return (Criteria) this;
        }

        public Criteria andPatIdLessThan(Long value) {
            addCriterion("PAT_ID <", value, "patId");
            return (Criteria) this;
        }

        public Criteria andPatIdLessThanOrEqualTo(Long value) {
            addCriterion("PAT_ID <=", value, "patId");
            return (Criteria) this;
        }

        public Criteria andPatIdIn(List<Long> values) {
            addCriterion("PAT_ID in", values, "patId");
            return (Criteria) this;
        }

        public Criteria andPatIdNotIn(List<Long> values) {
            addCriterion("PAT_ID not in", values, "patId");
            return (Criteria) this;
        }

        public Criteria andPatIdBetween(Long value1, Long value2) {
            addCriterion("PAT_ID between", value1, value2, "patId");
            return (Criteria) this;
        }

        public Criteria andPatIdNotBetween(Long value1, Long value2) {
            addCriterion("PAT_ID not between", value1, value2, "patId");
            return (Criteria) this;
        }

        public Criteria andPatNameIsNull() {
            addCriterion("PAT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andPatNameIsNotNull() {
            addCriterion("PAT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andPatNameEqualTo(String value) {
            addCriterion("PAT_NAME =", value, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameNotEqualTo(String value) {
            addCriterion("PAT_NAME <>", value, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameGreaterThan(String value) {
            addCriterion("PAT_NAME >", value, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameGreaterThanOrEqualTo(String value) {
            addCriterion("PAT_NAME >=", value, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameLessThan(String value) {
            addCriterion("PAT_NAME <", value, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameLessThanOrEqualTo(String value) {
            addCriterion("PAT_NAME <=", value, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameLike(String value) {
            addCriterion("PAT_NAME like", value, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameNotLike(String value) {
            addCriterion("PAT_NAME not like", value, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameIn(List<String> values) {
            addCriterion("PAT_NAME in", values, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameNotIn(List<String> values) {
            addCriterion("PAT_NAME not in", values, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameBetween(String value1, String value2) {
            addCriterion("PAT_NAME between", value1, value2, "patName");
            return (Criteria) this;
        }

        public Criteria andPatNameNotBetween(String value1, String value2) {
            addCriterion("PAT_NAME not between", value1, value2, "patName");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeIsNull() {
            addCriterion("MEDICAL_CARD_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeIsNotNull() {
            addCriterion("MEDICAL_CARD_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeEqualTo(Short value) {
            addCriterion("MEDICAL_CARD_TYPE =", value, "medicalCardType");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeNotEqualTo(Short value) {
            addCriterion("MEDICAL_CARD_TYPE <>", value, "medicalCardType");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeGreaterThan(Short value) {
            addCriterion("MEDICAL_CARD_TYPE >", value, "medicalCardType");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeGreaterThanOrEqualTo(Short value) {
            addCriterion("MEDICAL_CARD_TYPE >=", value, "medicalCardType");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeLessThan(Short value) {
            addCriterion("MEDICAL_CARD_TYPE <", value, "medicalCardType");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeLessThanOrEqualTo(Short value) {
            addCriterion("MEDICAL_CARD_TYPE <=", value, "medicalCardType");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeIn(List<Short> values) {
            addCriterion("MEDICAL_CARD_TYPE in", values, "medicalCardType");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeNotIn(List<Short> values) {
            addCriterion("MEDICAL_CARD_TYPE not in", values, "medicalCardType");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeBetween(Short value1, Short value2) {
            addCriterion("MEDICAL_CARD_TYPE between", value1, value2, "medicalCardType");
            return (Criteria) this;
        }

        public Criteria andMedicalCardTypeNotBetween(Short value1, Short value2) {
            addCriterion("MEDICAL_CARD_TYPE not between", value1, value2, "medicalCardType");
            return (Criteria) this;
        }

        public Criteria andMedicalCardIsNull() {
            addCriterion("MEDICAL_CARD is null");
            return (Criteria) this;
        }

        public Criteria andMedicalCardIsNotNull() {
            addCriterion("MEDICAL_CARD is not null");
            return (Criteria) this;
        }

        public Criteria andMedicalCardEqualTo(String value) {
            addCriterion("MEDICAL_CARD =", value, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardNotEqualTo(String value) {
            addCriterion("MEDICAL_CARD <>", value, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardGreaterThan(String value) {
            addCriterion("MEDICAL_CARD >", value, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardGreaterThanOrEqualTo(String value) {
            addCriterion("MEDICAL_CARD >=", value, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardLessThan(String value) {
            addCriterion("MEDICAL_CARD <", value, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardLessThanOrEqualTo(String value) {
            addCriterion("MEDICAL_CARD <=", value, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardLike(String value) {
            addCriterion("MEDICAL_CARD like", value, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardNotLike(String value) {
            addCriterion("MEDICAL_CARD not like", value, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardIn(List<String> values) {
            addCriterion("MEDICAL_CARD in", values, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardNotIn(List<String> values) {
            addCriterion("MEDICAL_CARD not in", values, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardBetween(String value1, String value2) {
            addCriterion("MEDICAL_CARD between", value1, value2, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andMedicalCardNotBetween(String value1, String value2) {
            addCriterion("MEDICAL_CARD not between", value1, value2, "medicalCard");
            return (Criteria) this;
        }

        public Criteria andRegFeeIsNull() {
            addCriterion("REG_FEE is null");
            return (Criteria) this;
        }

        public Criteria andRegFeeIsNotNull() {
            addCriterion("REG_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andRegFeeEqualTo(Integer value) {
            addCriterion("REG_FEE =", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeNotEqualTo(Integer value) {
            addCriterion("REG_FEE <>", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeGreaterThan(Integer value) {
            addCriterion("REG_FEE >", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("REG_FEE >=", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeLessThan(Integer value) {
            addCriterion("REG_FEE <", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeLessThanOrEqualTo(Integer value) {
            addCriterion("REG_FEE <=", value, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeIn(List<Integer> values) {
            addCriterion("REG_FEE in", values, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeNotIn(List<Integer> values) {
            addCriterion("REG_FEE not in", values, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeBetween(Integer value1, Integer value2) {
            addCriterion("REG_FEE between", value1, value2, "regFee");
            return (Criteria) this;
        }

        public Criteria andRegFeeNotBetween(Integer value1, Integer value2) {
            addCriterion("REG_FEE not between", value1, value2, "regFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeIsNull() {
            addCriterion("TREAT_FEE is null");
            return (Criteria) this;
        }

        public Criteria andTreatFeeIsNotNull() {
            addCriterion("TREAT_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andTreatFeeEqualTo(Integer value) {
            addCriterion("TREAT_FEE =", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeNotEqualTo(Integer value) {
            addCriterion("TREAT_FEE <>", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeGreaterThan(Integer value) {
            addCriterion("TREAT_FEE >", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("TREAT_FEE >=", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeLessThan(Integer value) {
            addCriterion("TREAT_FEE <", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeLessThanOrEqualTo(Integer value) {
            addCriterion("TREAT_FEE <=", value, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeIn(List<Integer> values) {
            addCriterion("TREAT_FEE in", values, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeNotIn(List<Integer> values) {
            addCriterion("TREAT_FEE not in", values, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeBetween(Integer value1, Integer value2) {
            addCriterion("TREAT_FEE between", value1, value2, "treatFee");
            return (Criteria) this;
        }

        public Criteria andTreatFeeNotBetween(Integer value1, Integer value2) {
            addCriterion("TREAT_FEE not between", value1, value2, "treatFee");
            return (Criteria) this;
        }

        public Criteria andChannelIsNull() {
            addCriterion("CHANNEL is null");
            return (Criteria) this;
        }

        public Criteria andChannelIsNotNull() {
            addCriterion("CHANNEL is not null");
            return (Criteria) this;
        }

        public Criteria andChannelEqualTo(String value) {
            addCriterion("CHANNEL =", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotEqualTo(String value) {
            addCriterion("CHANNEL <>", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelGreaterThan(String value) {
            addCriterion("CHANNEL >", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelGreaterThanOrEqualTo(String value) {
            addCriterion("CHANNEL >=", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLessThan(String value) {
            addCriterion("CHANNEL <", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLessThanOrEqualTo(String value) {
            addCriterion("CHANNEL <=", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLike(String value) {
            addCriterion("CHANNEL like", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotLike(String value) {
            addCriterion("CHANNEL not like", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelIn(List<String> values) {
            addCriterion("CHANNEL in", values, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotIn(List<String> values) {
            addCriterion("CHANNEL not in", values, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelBetween(String value1, String value2) {
            addCriterion("CHANNEL between", value1, value2, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotBetween(String value1, String value2) {
            addCriterion("CHANNEL not between", value1, value2, "channel");
            return (Criteria) this;
        }

        public Criteria andSpIdIsNull() {
            addCriterion("SP_ID is null");
            return (Criteria) this;
        }

        public Criteria andSpIdIsNotNull() {
            addCriterion("SP_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSpIdEqualTo(String value) {
            addCriterion("SP_ID =", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdNotEqualTo(String value) {
            addCriterion("SP_ID <>", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdGreaterThan(String value) {
            addCriterion("SP_ID >", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdGreaterThanOrEqualTo(String value) {
            addCriterion("SP_ID >=", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdLessThan(String value) {
            addCriterion("SP_ID <", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdLessThanOrEqualTo(String value) {
            addCriterion("SP_ID <=", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdLike(String value) {
            addCriterion("SP_ID like", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdNotLike(String value) {
            addCriterion("SP_ID not like", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdIn(List<String> values) {
            addCriterion("SP_ID in", values, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdNotIn(List<String> values) {
            addCriterion("SP_ID not in", values, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdBetween(String value1, String value2) {
            addCriterion("SP_ID between", value1, value2, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdNotBetween(String value1, String value2) {
            addCriterion("SP_ID not between", value1, value2, "spId");
            return (Criteria) this;
        }

        public Criteria andOperIsNull() {
            addCriterion("OPER is null");
            return (Criteria) this;
        }

        public Criteria andOperIsNotNull() {
            addCriterion("OPER is not null");
            return (Criteria) this;
        }

        public Criteria andOperEqualTo(String value) {
            addCriterion("OPER =", value, "oper");
            return (Criteria) this;
        }

        public Criteria andOperNotEqualTo(String value) {
            addCriterion("OPER <>", value, "oper");
            return (Criteria) this;
        }

        public Criteria andOperGreaterThan(String value) {
            addCriterion("OPER >", value, "oper");
            return (Criteria) this;
        }

        public Criteria andOperGreaterThanOrEqualTo(String value) {
            addCriterion("OPER >=", value, "oper");
            return (Criteria) this;
        }

        public Criteria andOperLessThan(String value) {
            addCriterion("OPER <", value, "oper");
            return (Criteria) this;
        }

        public Criteria andOperLessThanOrEqualTo(String value) {
            addCriterion("OPER <=", value, "oper");
            return (Criteria) this;
        }

        public Criteria andOperLike(String value) {
            addCriterion("OPER like", value, "oper");
            return (Criteria) this;
        }

        public Criteria andOperNotLike(String value) {
            addCriterion("OPER not like", value, "oper");
            return (Criteria) this;
        }

        public Criteria andOperIn(List<String> values) {
            addCriterion("OPER in", values, "oper");
            return (Criteria) this;
        }

        public Criteria andOperNotIn(List<String> values) {
            addCriterion("OPER not in", values, "oper");
            return (Criteria) this;
        }

        public Criteria andOperBetween(String value1, String value2) {
            addCriterion("OPER between", value1, value2, "oper");
            return (Criteria) this;
        }

        public Criteria andOperNotBetween(String value1, String value2) {
            addCriterion("OPER not between", value1, value2, "oper");
            return (Criteria) this;
        }

        public Criteria andOutBookIdIsNull() {
            addCriterion("OUT_BOOK_ID is null");
            return (Criteria) this;
        }

        public Criteria andOutBookIdIsNotNull() {
            addCriterion("OUT_BOOK_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOutBookIdEqualTo(String value) {
            addCriterion("OUT_BOOK_ID =", value, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdNotEqualTo(String value) {
            addCriterion("OUT_BOOK_ID <>", value, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdGreaterThan(String value) {
            addCriterion("OUT_BOOK_ID >", value, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdGreaterThanOrEqualTo(String value) {
            addCriterion("OUT_BOOK_ID >=", value, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdLessThan(String value) {
            addCriterion("OUT_BOOK_ID <", value, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdLessThanOrEqualTo(String value) {
            addCriterion("OUT_BOOK_ID <=", value, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdLike(String value) {
            addCriterion("OUT_BOOK_ID like", value, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdNotLike(String value) {
            addCriterion("OUT_BOOK_ID not like", value, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdIn(List<String> values) {
            addCriterion("OUT_BOOK_ID in", values, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdNotIn(List<String> values) {
            addCriterion("OUT_BOOK_ID not in", values, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdBetween(String value1, String value2) {
            addCriterion("OUT_BOOK_ID between", value1, value2, "outBookId");
            return (Criteria) this;
        }

        public Criteria andOutBookIdNotBetween(String value1, String value2) {
            addCriterion("OUT_BOOK_ID not between", value1, value2, "outBookId");
            return (Criteria) this;
        }

        public Criteria andTakeStatusIsNull() {
            addCriterion("TAKE_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andTakeStatusIsNotNull() {
            addCriterion("TAKE_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andTakeStatusEqualTo(Integer value) {
            addCriterion("TAKE_STATUS =", value, "takeStatus");
            return (Criteria) this;
        }

        public Criteria andTakeStatusNotEqualTo(Integer value) {
            addCriterion("TAKE_STATUS <>", value, "takeStatus");
            return (Criteria) this;
        }

        public Criteria andTakeStatusGreaterThan(Integer value) {
            addCriterion("TAKE_STATUS >", value, "takeStatus");
            return (Criteria) this;
        }

        public Criteria andTakeStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("TAKE_STATUS >=", value, "takeStatus");
            return (Criteria) this;
        }

        public Criteria andTakeStatusLessThan(Integer value) {
            addCriterion("TAKE_STATUS <", value, "takeStatus");
            return (Criteria) this;
        }

        public Criteria andTakeStatusLessThanOrEqualTo(Integer value) {
            addCriterion("TAKE_STATUS <=", value, "takeStatus");
            return (Criteria) this;
        }

        public Criteria andTakeStatusIn(List<Integer> values) {
            addCriterion("TAKE_STATUS in", values, "takeStatus");
            return (Criteria) this;
        }

        public Criteria andTakeStatusNotIn(List<Integer> values) {
            addCriterion("TAKE_STATUS not in", values, "takeStatus");
            return (Criteria) this;
        }

        public Criteria andTakeStatusBetween(Integer value1, Integer value2) {
            addCriterion("TAKE_STATUS between", value1, value2, "takeStatus");
            return (Criteria) this;
        }

        public Criteria andTakeStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("TAKE_STATUS not between", value1, value2, "takeStatus");
            return (Criteria) this;
        }

        public Criteria andTakeCodeIsNull() {
            addCriterion("TAKE_CODE is null");
            return (Criteria) this;
        }

        public Criteria andTakeCodeIsNotNull() {
            addCriterion("TAKE_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andTakeCodeEqualTo(String value) {
            addCriterion("TAKE_CODE =", value, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeNotEqualTo(String value) {
            addCriterion("TAKE_CODE <>", value, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeGreaterThan(String value) {
            addCriterion("TAKE_CODE >", value, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeGreaterThanOrEqualTo(String value) {
            addCriterion("TAKE_CODE >=", value, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeLessThan(String value) {
            addCriterion("TAKE_CODE <", value, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeLessThanOrEqualTo(String value) {
            addCriterion("TAKE_CODE <=", value, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeLike(String value) {
            addCriterion("TAKE_CODE like", value, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeNotLike(String value) {
            addCriterion("TAKE_CODE not like", value, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeIn(List<String> values) {
            addCriterion("TAKE_CODE in", values, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeNotIn(List<String> values) {
            addCriterion("TAKE_CODE not in", values, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeBetween(String value1, String value2) {
            addCriterion("TAKE_CODE between", value1, value2, "takeCode");
            return (Criteria) this;
        }

        public Criteria andTakeCodeNotBetween(String value1, String value2) {
            addCriterion("TAKE_CODE not between", value1, value2, "takeCode");
            return (Criteria) this;
        }

        public Criteria andBookStatusIsNull() {
            addCriterion("BOOK_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andBookStatusIsNotNull() {
            addCriterion("BOOK_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andBookStatusEqualTo(Integer value) {
            addCriterion("BOOK_STATUS =", value, "bookStatus");
            return (Criteria) this;
        }

        public Criteria andBookStatusNotEqualTo(Integer value) {
            addCriterion("BOOK_STATUS <>", value, "bookStatus");
            return (Criteria) this;
        }

        public Criteria andBookStatusGreaterThan(Integer value) {
            addCriterion("BOOK_STATUS >", value, "bookStatus");
            return (Criteria) this;
        }

        public Criteria andBookStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("BOOK_STATUS >=", value, "bookStatus");
            return (Criteria) this;
        }

        public Criteria andBookStatusLessThan(Integer value) {
            addCriterion("BOOK_STATUS <", value, "bookStatus");
            return (Criteria) this;
        }

        public Criteria andBookStatusLessThanOrEqualTo(Integer value) {
            addCriterion("BOOK_STATUS <=", value, "bookStatus");
            return (Criteria) this;
        }

        public Criteria andBookStatusIn(List<Integer> values) {
            addCriterion("BOOK_STATUS in", values, "bookStatus");
            return (Criteria) this;
        }

        public Criteria andBookStatusNotIn(List<Integer> values) {
            addCriterion("BOOK_STATUS not in", values, "bookStatus");
            return (Criteria) this;
        }

        public Criteria andBookStatusBetween(Integer value1, Integer value2) {
            addCriterion("BOOK_STATUS between", value1, value2, "bookStatus");
            return (Criteria) this;
        }

        public Criteria andBookStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("BOOK_STATUS not between", value1, value2, "bookStatus");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIsNull() {
            addCriterion("MODIFY_TIME is null");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIsNotNull() {
            addCriterion("MODIFY_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andModifyTimeEqualTo(Date value) {
            addCriterion("MODIFY_TIME =", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotEqualTo(Date value) {
            addCriterion("MODIFY_TIME <>", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeGreaterThan(Date value) {
            addCriterion("MODIFY_TIME >", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("MODIFY_TIME >=", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLessThan(Date value) {
            addCriterion("MODIFY_TIME <", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLessThanOrEqualTo(Date value) {
            addCriterion("MODIFY_TIME <=", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIn(List<Date> values) {
            addCriterion("MODIFY_TIME in", values, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotIn(List<Date> values) {
            addCriterion("MODIFY_TIME not in", values, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeBetween(Date value1, Date value2) {
            addCriterion("MODIFY_TIME between", value1, value2, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotBetween(Date value1, Date value2) {
            addCriterion("MODIFY_TIME not between", value1, value2, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andOrderSourceIsNull() {
            addCriterion("ORDER_SOURCE is null");
            return (Criteria) this;
        }

        public Criteria andOrderSourceIsNotNull() {
            addCriterion("ORDER_SOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSourceEqualTo(String value) {
            addCriterion("ORDER_SOURCE =", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceNotEqualTo(String value) {
            addCriterion("ORDER_SOURCE <>", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceGreaterThan(String value) {
            addCriterion("ORDER_SOURCE >", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_SOURCE >=", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceLessThan(String value) {
            addCriterion("ORDER_SOURCE <", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceLessThanOrEqualTo(String value) {
            addCriterion("ORDER_SOURCE <=", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceLike(String value) {
            addCriterion("ORDER_SOURCE like", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceNotLike(String value) {
            addCriterion("ORDER_SOURCE not like", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceIn(List<String> values) {
            addCriterion("ORDER_SOURCE in", values, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceNotIn(List<String> values) {
            addCriterion("ORDER_SOURCE not in", values, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceBetween(String value1, String value2) {
            addCriterion("ORDER_SOURCE between", value1, value2, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceNotBetween(String value1, String value2) {
            addCriterion("ORDER_SOURCE not between", value1, value2, "orderSource");
            return (Criteria) this;
        }

        public Criteria andHosNameIsNull() {
            addCriterion("HOS_NAME is null");
            return (Criteria) this;
        }

        public Criteria andHosNameIsNotNull() {
            addCriterion("HOS_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andHosNameEqualTo(String value) {
            addCriterion("HOS_NAME =", value, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameNotEqualTo(String value) {
            addCriterion("HOS_NAME <>", value, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameGreaterThan(String value) {
            addCriterion("HOS_NAME >", value, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameGreaterThanOrEqualTo(String value) {
            addCriterion("HOS_NAME >=", value, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameLessThan(String value) {
            addCriterion("HOS_NAME <", value, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameLessThanOrEqualTo(String value) {
            addCriterion("HOS_NAME <=", value, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameLike(String value) {
            addCriterion("HOS_NAME like", value, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameNotLike(String value) {
            addCriterion("HOS_NAME not like", value, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameIn(List<String> values) {
            addCriterion("HOS_NAME in", values, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameNotIn(List<String> values) {
            addCriterion("HOS_NAME not in", values, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameBetween(String value1, String value2) {
            addCriterion("HOS_NAME between", value1, value2, "hosName");
            return (Criteria) this;
        }

        public Criteria andHosNameNotBetween(String value1, String value2) {
            addCriterion("HOS_NAME not between", value1, value2, "hosName");
            return (Criteria) this;
        }

        public Criteria andDocNameIsNull() {
            addCriterion("DOC_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDocNameIsNotNull() {
            addCriterion("DOC_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDocNameEqualTo(String value) {
            addCriterion("DOC_NAME =", value, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameNotEqualTo(String value) {
            addCriterion("DOC_NAME <>", value, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameGreaterThan(String value) {
            addCriterion("DOC_NAME >", value, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameGreaterThanOrEqualTo(String value) {
            addCriterion("DOC_NAME >=", value, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameLessThan(String value) {
            addCriterion("DOC_NAME <", value, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameLessThanOrEqualTo(String value) {
            addCriterion("DOC_NAME <=", value, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameLike(String value) {
            addCriterion("DOC_NAME like", value, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameNotLike(String value) {
            addCriterion("DOC_NAME not like", value, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameIn(List<String> values) {
            addCriterion("DOC_NAME in", values, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameNotIn(List<String> values) {
            addCriterion("DOC_NAME not in", values, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameBetween(String value1, String value2) {
            addCriterion("DOC_NAME between", value1, value2, "docName");
            return (Criteria) this;
        }

        public Criteria andDocNameNotBetween(String value1, String value2) {
            addCriterion("DOC_NAME not between", value1, value2, "docName");
            return (Criteria) this;
        }

        public Criteria andDeptNameIsNull() {
            addCriterion("DEPT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDeptNameIsNotNull() {
            addCriterion("DEPT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDeptNameEqualTo(String value) {
            addCriterion("DEPT_NAME =", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotEqualTo(String value) {
            addCriterion("DEPT_NAME <>", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameGreaterThan(String value) {
            addCriterion("DEPT_NAME >", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameGreaterThanOrEqualTo(String value) {
            addCriterion("DEPT_NAME >=", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLessThan(String value) {
            addCriterion("DEPT_NAME <", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLessThanOrEqualTo(String value) {
            addCriterion("DEPT_NAME <=", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLike(String value) {
            addCriterion("DEPT_NAME like", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotLike(String value) {
            addCriterion("DEPT_NAME not like", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameIn(List<String> values) {
            addCriterion("DEPT_NAME in", values, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotIn(List<String> values) {
            addCriterion("DEPT_NAME not in", values, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameBetween(String value1, String value2) {
            addCriterion("DEPT_NAME between", value1, value2, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotBetween(String value1, String value2) {
            addCriterion("DEPT_NAME not between", value1, value2, "deptName");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table gh_order
     *
     * @mbggenerated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}